home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
equiptype.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
33 lines
/* RCSVER $Id: equiptype.sql,v 1.2 1999-02-24 11:28:09-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: equiptype.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the equiptype table. This table contains all
* equipment type definitions, including buses, farebox
* equipment, and programs.
* Changes:
************************************************************************* */
/* EQUIPTYPE
100 Farebox 1000000 - 1009999
101 Cashbox 1010000 - 1019999
102 Bus
103 Garage
104 Moneyroom
105 Truck
106 Money receptacle
107 Computer
108 Wayfarer ticket unit
*/
CREATE TABLE equiptype
(
equip_type NUMBER(38), /* Type of equipment */
is_optional NUMBER(1) DEFAULT 0, /* Boolean - optional ? */
descr VARCHAR2(40), /* Description of equiptype */
beg_glid NUMBER(38), /* Beginning ID for this type */
end_glid NUMBER(38), /* Ending ID for this type */
CONSTRAINT pk_equiptype PRIMARY KEY (equip_type)
);